SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE dbo.[DnnProduct_CDS_DistributorBillingConfigAdd]
	@DistributorID varchar(50),
    @BillingConfigID int,
    @BillingStartDate datetime,
    @TrialAccount bit,
    @TrialAccountDate datetime,
    @ContractDate datetime,
    @ServiceStatement int,
    @AcumenID int,
    @CurrencyID int,
    @ExchangeRate decimal(12, 4),
    @Enabled bit
AS
BEGIN
	INSERT INTO [DnnProduct_CDS_DistributorBillingConfig]
           ([DistributorID],
           [BillingConfigID],
           [BillingStartDate],
           [TrialAccount],
           [TrialAccountDate],
           [ContractDate],
           [ServiceStatement],
           [AcumenID],
           [CurrencyID],
           [ExchangeRate],
           [Enabled])
     VALUES
           (@DistributorID,
           @BillingConfigID,
           @BillingStartDate,
           @TrialAccount,
           @TrialAccountDate,
           @ContractDate,
           @ServiceStatement,
           @AcumenID,
           @CurrencyID,
           @ExchangeRate,
           @Enabled)

	SELECT SCOPE_IDENTITY()
END
GO
